package com.eight.clienthome.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.eight.common.pojo.TbZone;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 向文豪
 * @program: eight-education-parent
 * @description:
 * @date 2023/6/2 11:07
 */
public interface ZoneDao extends BaseMapper<TbZone> {
    @Select("select z.zone_name name, ec.title title from edu_course ec join tb_zone_course zc on ec.id = zc.course_id join tb_zone z on zc.zone_id=z.id ")
    List<TbZone> findAll();


}
